package com.usian.springbootmysql.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.usian.springbootmysql.dao.CollegeDao;
import com.usian.springbootmysql.pojo.ResultVo;
import com.usian.springbootmysql.pojo.Searchdto;
import com.usian.springbootmysql.pojo.TbCollege;
import com.usian.springbootmysql.service.CollegeService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.StringUtils;

import java.util.List;

@Service
public class CollegeServiceImpl extends ServiceImpl<CollegeDao, TbCollege> implements CollegeService {
    @Autowired
    private CollegeDao collegeDao;

    @Override
    public ResultVo saveCollege(TbCollege tbCollege)
    {
//        QueryWrapper<TbCollege> query = new QueryWrapper<TbCollege>();
//        query.eq("name",tbCollege.getName());
        LambdaQueryWrapper<TbCollege> lambdaQueryWrapper=new LambdaQueryWrapper<TbCollege>();
    lambdaQueryWrapper.eq(TbCollege::getName,tbCollege.getName());
        int count=collegeDao.selectCount(lambdaQueryWrapper);



    if (count>0){
                return new ResultVo(201,"名称存在",null);
        }else {
                collegeDao.insert(tbCollege);
                return new ResultVo(200,"名称不存在添加成功",null);
        }
    }

    @Override
    public List<TbCollege> search(String status) {
        LambdaQueryWrapper<TbCollege> lambdaQueryWrapper=new LambdaQueryWrapper<TbCollege>();
        lambdaQueryWrapper.eq(TbCollege::getStatus,status);
        List<TbCollege> list=collegeDao.selectList(lambdaQueryWrapper);
        return list;
    }

    @Override
    public List<TbCollege> searchvo(TbCollege tbCollege) {
        LambdaQueryWrapper<TbCollege> lambdaQueryWrapper=new LambdaQueryWrapper<TbCollege>();
        if (!StringUtils.isEmpty(tbCollege.getName())){
            lambdaQueryWrapper.like(TbCollege::getName,tbCollege.getName());
        }
        if (tbCollege.getStatus()!=null){
            lambdaQueryWrapper.eq(TbCollege::getStatus,tbCollege.getStatus());
        }

        List<TbCollege> list = collegeDao.selectList(lambdaQueryWrapper);
        return list;
    }

    @Override
    public IPage<TbCollege> searchPage(Searchdto searchdto) {
        IPage<TbCollege> page=new Page<TbCollege>(searchdto.getPage(),searchdto.getSize());

        LambdaQueryWrapper<TbCollege> lambdaQueryWrapper=new LambdaQueryWrapper<TbCollege>();

        if (!StringUtils.isEmpty(searchdto.getName())){
            lambdaQueryWrapper.like(TbCollege::getName,searchdto.getName());
        }
        if (searchdto.getStatus()!=null){
            lambdaQueryWrapper.eq(TbCollege::getStatus,searchdto.getStatus());
        }

        IPage<TbCollege> list = collegeDao.selectPage(page,lambdaQueryWrapper);
        collegeDao.selectPage(page,lambdaQueryWrapper);
        return list;
    }
}
